Transforming Queries from a Relational Schema to an Equivalent Object Schema: A Prototype Based on F-logic1

نویسنده

  • Yahui Chang
چکیده

This paper describes a technique to support interoperable query processing when multiple heterogeneous knowledge servers are accessed. The problem is to support query transformation transparently, so a user can pose queries locally, without any need of global knowledge about diierent data models and schema. In a companion paper, an architecture for supporting interoperability was described and we provided some details of transforming queries from an object schema to an equivalent relational schema. In this paper, we focus on transforming SQL source queries, posed against a rela-tional schema, to XSQL queries to be evaluated against equivalent object schema. We describe some functional modules in detail, namely an extractor module (EM) which extracts semantics from a source query, and a heterogeneous mapping module (HTM) which maps among entities in diierent schema, based on some mapping rules which reeect global knowledge of the models, schema and query languages. The local and global dictionary knowledge is represented in a canonical form, using a high-level logic representation, namely F-logic.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Transforming Queries from a Relational Schema to an Equivalent Object Schema: A Prototype Based on F-logic

This paper describes a technique to support interoperable query processing when multiple heterogeneous knowledge servers are accessed. The problem is to support query transformation transparently, so a user can pose queries locally, without any need of global knowledge about diierent data models and schema. In a companion paper, an architecture for supporting interoperability was described and ...

متن کامل

Language-integrated querying of XML data in SQL server

Developers need to access persistent XML data programmatically. Object-oriented access is often the preferred method. Translating XML data into objects or vice-versa is a hard problem due to the data model mismatch and the difficulty of query translation. Our prototype addresses this problem by transforming object-based queries and updates into queries and updates on XML using declarative mappi...

متن کامل

Object-Oriented Querying of Existing Relational Databases

In this paper, we present algorithms which allow an object-oriented querying of existing relational databases. Our goal is to provide an improved query interface for relational systems with better query facilities than SQL. This seems to be very important since, in real world applications, relational systems are most commonly used and their dominance will remain in the near future. To overcome ...

متن کامل

Object-Oriented Querying of Existing Relations Databases

In this paper, we present algorithms which allow an object-oriented querying of existing relational databases. Our goal is to provide an improved query interface for relational systems with better query facilities than SQL. This seems to be very important since, in real world applications, relational systems are most commonly used and their dominance will remain in the near future. To overcome ...

متن کامل

Transforming Queries from a RelationalSchema to an Object Schema : A PrototypeBased on F - logic ?

This paper describes a technique to support interoperable query processing when multiple heterogeneous databases are accessed. The problem is to support query transformation transparently, so a user can pose queries locally, without any need of global knowledge about different data models and schema. In this paper, we focus on transforming SQL source queries, posed against a relational schema, ...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2007